4005|Profitability By DIM3

Menu location

FTP4 >> FTP Profitability Analysis >> Profitability By DIM3

Applicable for roles

• RMUSER (RM USER)
• RMUSER_M (RMUSER Maker)
• RMUSER_C (RMUSER Checker)

Parameters

Global

#	Parameters	Example
1	✅ AsOn	dd-mm-yyyy
2	✅ Denomination	Thousands

Local

#	Parameters	Example
1	✅ Hierarchy	All
2	✅ Display	Profitability and Margin

App Configurations:

Config Key	Config Value	Explaination
DIM1	DIM3	The name for the dimension.
Denom	1	Default Denomination Value
DenomDesc	Unit	Default Denomination Description

Report specific

• This report is generated for consolidated currency.
• No currency filter is applied for this report.

Report details

Screenshot

Report Behaviour

1. In case data does not exist for the selected AsOn Date, a custom exception is thrown and export and print buttons are hidden.
2. In case Hierarchy is not defined for the DIM3s, 'ALL' is the only binded hierarchy.
3. In case Display Dropdown in not bound, it throws application error.

Logic

Formulas

#	Value	Formula
1	Net Interest Income	Interest Income - Interest Expense
2	FTP Margin	FTP Income - FTP Expense
3	Net Margin	Asset Margin + Liability Margin
4	Asset Average Balance	Sum(BalAmtHCY) where AorL == 'A'
5	Interest Income	Sum(IntAmtHCY) where AorL == 'A'
6	FTP Expense	Sum(FTPAmtHCY) where AorL == 'A'
7	Asset Margin	Interest Income - FTP Expense
8	Interest Income Rate	Sum(BalAmtHCY * AvgIntRate) / Sum(BalAmtHCY) where AorL == 'A'
9	FTP Expense Rate	Sum(BalAmtHCY * AvgFTPRate) / Sum(BalAmtHCY) where AorL == 'A'
10	Asset Spread	Interest Income Rate - FTP Expense Rate
11	Liability Average Balance	Sum(BalAmtHCY) where AorL == 'L'
12	Interest Expense	Sum(IntAmtHCY) where AorL == 'L'
13	FTP Income	Sum(FTPAmtHCY) where AorL == 'L'
14	Liability Margin	FTP Income - Interest Expense
15	Interest Expense Rate	Sum(BalAmtHCY * AvgIntRate) / Sum(BalAmtHCY) where AorL == 'L'
16	FTP Income Rate	Sum(BalAmtHCY * AvgFTPRate) / Sum(BalAmtHCY) where AorL == 'L'
17	Liability Spread	FTP Income Rate - Interest Expense Rate

Export

Export button at top right corner gives the option to download the report in 4 formats #|Format| ----|-------| 1|EXCEL| 2|PDF| 3|CSV| 4|TXT|

Dependencies:

#	Search/Dropdown Field	Table Or view Used	Screen available to add/edit	Screen details
1	Display	tblCommonCodes	No	------

Drill Down Reports

Product Level Drilldown

Possible errors:

ErrorCode	ErrorMessage	Cause of error
BLF02032	Data does not exist for {0}.	If Records are not present for selected AsOnDate